Copyright: This file © Dariusz Dziewialtowski 10/11/2003


Help file produced by

HELLLP!

www.guysoftware.com/helllp.html

(If this topic is presented in file testing the

author should use the HELLLP! I

button to define a contents topic)


SQL Server Comparison Tool Helpyesyesyesyes31Dct_helpyesyes11/10/03


Table of Contents

	SCT User's Guide Help               © 2003 AlfaAlfa Software
__________________________________________

Introduction

Benefits of Buying SQL Server Comparison Tool

Adding SQL Server to SCT

Removing SQL Server from SCT

Keyboard Shortcuts

Toolbar

Getting database information

Exporting data from table to Excel file

Exporting data from table to HTML file

Comparing selected objects

Comparing all objects

Comparing data in two tables

Filtering objects by their ownerships

End-User License Agreement

Buying Information

Order Form (Paying by Check)

Technical Support

___________________________________________


Help file produced by  HELLLP! v3.1b , a product of Guy Software, on 10/11/2003 for Dariusz Dziewialtowski.

The above table of contents will be automatically completed and will also provide an excellent cross-reference for context strings and topic titles.  You may leave it as your main table of contents for your help file, or you may create your own and cause it to be displayed instead by using the I button on the toolbar.  This page will not be displayed as a topic.  It is given a context string of _._ , but this is not presented for jump selection.

HINT:  If you do not wish some of your topics to appear in the table of contents as displayed to your users (you may want them ONLY as PopUps), move the lines with their titles and contexts to below this point.  If you do this remember to move the whole line, not part.  As an alternative, you may wish to set up your own table of contents, see Help under The Structure of a Help File.

  Do not delete any codes in the area above the Table of Contents title, they are used internally by HELLLP!


Introduction

Welcome to SQL Server Comparison Tool

With SQL Server Comparison Tool, you can take full control of your databases. You can

•	Analyze and compare structure of Tables, Procedures, Functions, Views, Triggers and Relationships in any of your SQL Server databases

•	Compare data stored in tables

•	Generate detailed reports displaying results of comparisons or analysis

•	Monitor changes done to the databases

•	Export data differences reports to HTML file or Excel (CSV) file (even if the computer performing analysis doesn’t have Excel installed)

•	New! Filter objects by their ownerships.

Analysis and comparisons can be performed even on databases belonging to different servers.

SQL Server Comparison Tool is an ideal tool for Database Administrators and Developers.

Please note that SQL Server Comparison Tool is very safe, “read-only” program.  Using it will never affect any data stored in your databases.  SCT is a tool designed to perform analysis and comparisons; it is not designed to change any structure or data.


Benefits of Buying Database Comparison Tool
Benefits of Buying SQL Server Comparison Tool

You may use evaluation version of SQL Server Comparison Tool for 30 days.

If after 30 days you would like to continue using SCT then you must buy the licensed version.

•	Registered users are entitled to 50% discount on all future versions of SCT.

•	As a registered user you will get FREE technical support lifetime.

•	We offer an unconditional 60-day money-back guarantee!

•	Your name will be displayed on the About dialog box.

•	There is no time limit on usage of registered version.


Keyboard Shortcuts

Action	Press
Display Help file	F1
Connect to the server	F5
Select object type	F6
Compare selected procedures	F7
Compare all objects	F8
Compare data in selected tables	F9
Display database information	F10
Copy selected object structure to the clipboard	Alt + O for Source database Alt + Y for Target database
Copy selected object structure to the file	Alt + P for Source database Alt + I for Target database
View data stored in selected table	Alt + V for Source database Alt + W for Target database
Display Tip of the Day	Ctrl + F1
Display About info	Shift + F1
Close the program	Alt + F4


Toolbar

Using a mouse, you can perform tasks quickly and easily by choosing buttons on the SQL Server Comparison Tool toolbar.

SCT toolbar has the following buttons:

Connect to the server

	Connects to SQL Server. Please note that before connecting for first time you have to add SQL Server to SCT.

Select object type

	Allows for selection of active objects. By default the selection is set to Tables, but you can change it by expanding the list (by clicking on the small arrow displayed on the right side) and selecting one of the object types: Tables, Procedures, Functions, Views, Triggers, Relationships.

Compare Selected Procedures

	Performs comparison of currently selected objects (if current object type is Tables, active Tables are being compared; if currently selected objects are Procedures, active Procedures are compared, etc).

Compare All Objects

	Displays dialog box which lets you specify which objects you want to compare. Let’s assume that all Tables and all Procedures were selected from the list - clicking Compare button starts comparison process, which results in generating detailed report.

Compare Data in Selected Tables

	This button works only when current Object Type is set to Tables. Clicking this button results in performing comparison of data stored in selected tables and displaying detailed report. Please note that comparison of data can be performed only if both Tables have the same structure (the same number of columns, all corresponding columns having the same data type).

Help

	Displays Help file.

Please note that SQL Server Comparison Tool has optionally mouseless interface - anything you can do with mouse, you can do also by using just keyboard. For list of shortcuts see Keyboard Shortcuts section.


Adding SQL Server to DCT
Adding SQL Server to SCT

Adding SQL Server to SCT is pretty much similar to registering SQL Server in such Microsoft tools like SQL Server Enterprise Manager or Query Analyzer

Invoke “Add SQL Server” dialog by selecting menu item Tools -> Add Server. Then just enter data into appropriate boxes and click button OK. SCT will attempt to connect to newly registered server. On successful attempt the process of adding SQL Server to SCT will be finished. In case when the connection fails, appropriate message will be displayed.

Please note that adding or removing server’s info to SCT is not affecting in any way the original settings for the server.


Removing SQL Server from DCT
Removing SQL Server from SCT

Removing (unregistering) SQL Server from SCT is very simple. Invoke appropriate dialog by selecting menu item Tools -> Remove Server, select server you wish to be removed, and click button “Remove”.

Please note that adding or removing server’s info to SCT is not affecting in any way the original settings for the server.


Getting database information

To get information about currently selected database click the button “Database info” or press F10.

SCT will perform analysis of the database and create report with the count and list of all tables, procedures, functions, views, triggers and relationships. The report will also indicate the number of data rows contained in each table.


Exporting data from table to Excel file

To export data from table to Excel file:

•	Select desired table

•	Click button “View Data”

•	New window will pop up, displaying all data stored in selected table. Click button “Export”

•	Select appropriate file type (in this case select: “Excel - Comma Separated Values (CSV) file”)

•	Click button “OK”

•	Select the location and name of the file to be created.

•	Click button “Save”. The new file will be created.


Exporting data from table to HTML file

To export data from table to HTML file:

•	Select desired table

•	Click button “View Data”

•	New window will pop up, displaying all data stored in selected table. Click button “Export”

•	Select appropriate file type (in this case select: “Hyper Text Markup Language (HTML) file”)

•	Click button “OK”

•	Select the location and name of the file to be created

•	Click button “Save”. The new file will be created.


Comparing selected objects

To compare selected objects:

•	Select the desired object type (Tables, Procedures, Functions, Views, Triggers or Relationships) using combo box on the toolbar

•	Select the objects to be compared

•	Click button “Compare Sel. Proc.”

The comparison will be performed and the results will be displayed.


Comparing all objects

To compare all objects in both databases:

•	Click button “Compare All”

•	The dialog box will be displayed

•	Select the object types you want to be compared and click button “Compare”

The comparison process can take couple of minutes; during this process status of the operation will be displayed.

At the end of the process appropriate report will be displayed
.


Comparing data in two tables

To compare data stored in two tables:

•	Select appropriate tables in both panels (left panel and right panel)

•	Click button “Compare data”

The comparison of data stored will be performed and the results will be displayed in Report window. You can export the report to HTML file or to Excel (CSV) file.

Please note that in order to compare data in two tables these tables have to have the same structure, i.e. the same number and type of columns.


Filtering objects by their ownerships

The program can show Ownership property of objects, and filter objects (like tables, procedures, functions) by their Ownerhip.

Each database object is owned by either a user or a role.  If the owner is a role, the object is co-owned by every user belonging to that role.

(Each object also has privileges associated with it.  A privilege grants a particular authority to an object for either an individual user or for all users belonging to a particular role.)

To set on an option ‘Show Ownership of database objects’ follow these steps:

•	Click menu item Tools -> Options.

•	Select tab “Show Owners”.

•	Check on the checkbox with caption “Show Ownership of database objects” by clicking it or by selecting it and pressing space bar on the keyboard.

•	Close “Options” dialog box.

After that, two additional combo boxes will show up on left and right panel, as shown on the image below.  Now you can filter displayed objects by their ownerships by selecting desired owners from combo boxes

To set off an option “Show Ownership of database objects“, uncheck the checkbox “Show Ownership of database objects” on “Options” dialog box.


End-User License Agreement

SQL Server Comparison Tool(tm) License Agreement

SQL SERVER COMPARISON TOOL VERSION 1.2 END-USER LICENSE AGREEMENT

IMPORTANT-READ CAREFULLY: This SQL Server Comparison Tool End-User License Agreement ("EULA") is a legal agreement between you (either an individual or a single entity) and AlfaAlfa Software (DTS) for the DTS SOFTWARE(s) identified above, which includes any associated SOFTWARE components, any media, any printed materials, and any "online" or electronic documentation ("SOFTWARE"). By installing, copying, or otherwise using the SOFTWARE, you agree to be bound by the terms of this EULA. If you do not agree to the terms of this EULA, do not install or use the SOFTWARE. If the SOFTWARE was mailed to you, return the media envelope, UNOPENED, along with the rest of the package to the location where you obtained it within 30 days from purchase.

1. The SOFTWARE is licensed, not sold.

2. GRANT OF LICENSE.

(a)	Evaluation Copy. You may use the SOFTWARE without charge on an evaluation basis for thirty (30) days from the day that you install the SOFTWARE. You must pay the license fee and register your copy to continue to use the SOFTWARE after the thirty (30) days. If you continue to use the SOFTWARE after the thirty (30) days without paying the license fee you will be using the SOFTWARE on an unlicensed basis.

(b)	Redistribution of Evaluation Copy. If you are using SOFTWARE on an evaluation basis you may make copies of the evaluation SOFTWARE as you wish; give exact copies of the original evaluation SOFTWARE to anyone; and distribute the evaluation SOFTWARE in its unmodified form via electronic means (Internet, BBS's, Shareware distribution libraries, CD-ROMs, etc.). You may not charge any fee for the copy or use of the evaluation SOFTWARE itself, but you may charge a distribution fee that is reasonably related to any cost you incur distributing the evaluation SOFTWARE (e.g. packaging). You must not represent in any way that you are selling the SOFTWARE itself. Your distribution of the evaluation SOFWARE will not entitle you to any compensation from AlfaAlfa Software. You must distribute a copy of this EULA with any copy of the SOFTWARE and anyone to whom you distribute the SOFTWARE is subject to this EULA.

(c)	Registered Copy. After you have purchased the license for the SOFTWARE, and have received the file enabling the registered copy, you are licensed to copy the SOFTWARE only into the memory of the number of computers corresponding to the number of licenses purchased. The primary user of the computer on which each licensed copy of the SOFTWARE is installed may make a second copy for his or her exclusive use on a portable computer. Under no other circumstances may the SOFTWARE be operated at the same time on more than the number of computers for which you have paid a separate license fee. You may not duplicate the SOFTWARE in whole or in part, except that you may make one copy of the SOFTWARE for backup or archival purposes. You may terminate this license at any time by destroying the original and all copies of the SOFTWARE in whatever form. You may permanently transfer all of your rights under this EULA provided you transfer all copies of the SOFTWARE (including copies of all prior versions if the SOFTWARE is an upgrade) and retain none, and the recipient agrees to the terms of this EULA.

3. RESTRICTIONS. You may not reverse engineer, de-compile, or disassemble the SOFTWARE, except and only to the extent that such activity is expressly permitted by applicable law notwithstanding this limitation. You may not rent, lease, or lend the SOFTWARE. You may permanently transfer all of your rights under this EULA, provided the recipient agrees to the terms of this EULA. You may not use the SOFTWARE to perform any unauthorized transfer of information (e.g. transfer of files in violation of copyright) or for any illegal purpose.

4. SUPPORT SERVICES. AlfaAlfa Software may provide you with support services related to the SOFTWARE. Use of Support Services is governed by the AlfaAlfa Software polices and programs described in the user manual, in online documentation, and/or other DTS-provided materials, as they may be modified from time to time. Any supplemental SOFTWARE code provided to you as part of the Support Services shall be considered part of the SOFTWARE and subject to the terms and conditions of this EULA. With respect to technical information you provide to AlfaAlfa as part of the Support Services, AlfaAlfa may use such information for its business purposes, including for product support and development. AlfaAlfa will not utilize such technical information in a form that personally identifies you.

5. TERMINATION. Without prejudice to any other rights, AlfaAlfa may terminate this EULA if you fail to comply with the terms and conditions of this EULA. In such event, you must destroy all copies of the SOFTWARE.

6. COPYRIGHT. The SOFTWARE is protected by Canadian copyright law and international treaty provisions. You acknowledge that no title to the intellectual property in the SOFTWARE is transferred to you. You further acknowledge that title and full ownership rights to the SOFTWARE will remain the exclusive property of AlfaAlfa and you will not acquire any rights to the SOFTWARE except as expressly set forth in this license. You agree that any copies of the SOFTWARE will contain the same proprietary notices which appear on and in the SOFTWARE.

7. NO WARRANTIES. ALFAALFA SOFTWARE EXPRESSLY DISCLAIMS ANY WARRANTY FOR THE SOFTWARE. THE SOFTWARE AND ANY RELATED DOCUMENTATION IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OR MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NONINFRINGEMENT. THE ENTIRE RISK ARISING OUT OF USE OR PERFORMANCE OF THE SOFTWARE REMAINS WITH YOU.

8. LIMITATION OF LIABILITY. IN NO EVENT SHALL ALFAALFA SOFTWARE OR ITS SUPPLIERS BE LIABLE TO YOU FOR ANY CONSEQUENTIAL, SPECIAL, INCIDENTAL, OR INDIRECT DAMAGES OF ANY KIND ARISING OUT OF THE DELIVERY, PERFORMANCE, OR USE OF THE SOFTWARE, EVEN IF ALFAALFA SOFTWARE HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. IN ANY EVENT, DTS'S LIABILITY FOR ANY CLAIM, WHETHER IN CONTRACT, TORT, OR ANY OTHER THEORY OF LIABILITY WILL NOT EXCEED THE GREATER OF U.S. $1.00 OR LICENSE FEE PAID BY YOU.

9. MISCELLANEOUS. If you acquired the SOFTWARE in Canada, this EULA is governed by the laws of the province Ontario. If you acquired the SOFTWARE outside of Canada, the local laws may apply.

Should you have any questions concerning this EULA, or if you desire to contact AlfaAlfa Software for any reason, please contact AlfaAlfa Software by electronic mail at: admin@sql-server-tool.com.


Buying Information

All orders are subject to the SQL Server Comparison Tool(tm) License Agreement.

Online Delivery

Online delivery of registration keys for SQL Server Comparison Tool is available for credit card orders placed via the Internet using the Order link at the SQL Server Comparison Tool web site:

http://www.sql-server-tool.com.

You can place orders for delivery by postal mail (or airmail outside North America) using the Internet order forms or as described below.

Ordering by Check

To order by check, send a completed order form and a check payable to Dariusz Dziewialtowski, 71 St Hubert Ave, M4J 3Z2 Toronto, Ontario, Canada.  Payments must be in US dollars drawn on a US bank, or you can send international postal money orders in US dollars.  Click here to view a ready-to-print Order Form.

Credit Card Orders

You can place secure credit card orders on the Internet using the Order link on the SQL Server Comparison Tool web site:

http://www.sql-server-tool.com

For information on credit card ordering by phone, fax, or postal mail, see SQL Server Comparison Tool web site.

Pricing

Single License:	$99.00
Five Pack License:	$299.00
Twenty Five Pack License:	$999.00

Prices are in US dollars and are guaranteed through year 2003.

If you need a quote for higher quantity site licenses, please send e-mail to sales@sql-server-tool.com.

You can also buy via phone, fax or postal mail.

For more details, follow the link

http://www.sql-server-tool.com/order.html.

___________________________________________

You can also have branded version of SQL Server Comparison Tool (with your company name, logos and details embedded into the program). For a quote on a price please contact us at sales@sql-server-tool.com.

Please note that for $2,999.00 you can also buy source code of SQL Server Comparison Tool. For more information contact us at sales@sql-server-tool.com.

We also offer consulting services to other companies. Our speciality is database programs.

Thank you for your business!


Order Form (Paying by Check)

To print this order form, select Print Topic from the File pull-down menu.

To order by check, send this completed order form and a check (in US dollars drawn on a US bank) payable to Dariusz Dziewialtowski, 71 St Hubert Ave, M4J 3Z2 Toronto, Ontario, Canada.  All orders are subject to the SQL Server Comparison Tool(tm) License Agreement.

Customer information is considered confidential and will not be shared or distributed to any third party.

SCT Single License	_____ at	 $99.00 each =	__________

Five Pack License	 	_____ at	$299.00 each =	__________

Twenty Five Pack License:	_____ at	$999.00 each =	__________

Total payment:	__________

Prices are in US dollars and are guaranteed through year 2003.

If you need a quote for higher quantity site licenses, please send e-mail to sales@sql-server-tool.com.

Date:	____________________________________________________________

Name:	____________________________________________________________

Company:	____________________________________________________________

Shipping Address:	____________________________________________________________

____________________________________________________________

City, State, Zip:	____________________________________________________________

Country:	____________________________________________________________

Day Phone:	____________________________________________________________

E-Mail address:	____________________________________________________________

How would you like to receive the registration key?

Email ___   fax ___ postal mail ___

How did you hear about SQL Server Comparison Tool?

_____________________________________________________________________________

Comments:


Technical Support

For the most recent updates of SQL Server Comparison Tool, please check its home page at

http://www.sql-server-tool.com.

Technical support is available at no charge as described below.

To report problems you can send e-mail to admin@sql-server-tool.com or postal mail to AlfaAlfa Software, 71 St Hubert Ave, M4J 3Z2 Toronto, Ontario, Canada.

When reporting problems, please include the following information:

1.	What version of SCT you are running (1.0, 1.1, etc)?

2.	What version of Windows are you running (Windows 2000, Windows NT 4.0, etc.)?

3.	What version of SQL Server are you running (SQL Server 2000, SQL Server 7.0, etc)?

4.	Is the problem reproducible?  If so, how?